Versions:
CubeScope, published by David Simon and currently at version 0.10.0 (the only released version listed), is a modern, open-source successor to MDX Studio designed for SQL Server Analysis Services (SSAS) Multidimensional developers. It functions as a complete workbench for writing, understanding, measuring, and maintaining MDX queries against existing cubes, with a built-in AI expert. The software is distributed as a single self-contained executable combining ASP.NET Core 10 and Vue 3, which opens a local web application in the browser with no installation, server, or cloud dependency required. Its feature set includes a Monaco MDX editor with autocompletion, a virtualized results grid, a DMV metadata explorer, and a query profiler that distinguishes Formula Engine versus Storage Engine activity from SSAS traces, alongside perfmon statistics, an MDX Script dependency graph, cache management, and query history. The AI assistant can explain, optimize, and format MDX, detect anti-patterns, provide profile-grounded optimization suggestions, and generate MDX from natural language. It is powered by Anthropic by default, but can also connect to any OpenAI-compatible endpoint, including local options such as Ollama or LM Studio, to preserve on-premises confidentiality. CubeScope falls within the database development and business intelligence tooling category, specifically targeting MDX query development, performance analysis, and cube administration use cases. It is a practical choice for organizations maintaining legacy SSAS Multidimensional environments that need modern editing, profiling, and AI-assisted tooling without deploying server infrastructure. The application runs on Windows only and uses Integrated Security for authentication. Its scope is deliberately limited to SSAS Multidimensional; it does not support Tabular models, Power BI, or DAX, making it a focused utility for a well-defined niche rather than a general-purpose analytics platform.
Tags: